Importing the data into Power BI:
1.
Open Power BI.
2.
Click Get Data.
3.
Click SQL Server Database.
4.
Now where it says Server type your server’s name. If you don’t
know it head over to SQL and type this out, SELECT @@SERVERNAME
5. Once file is loaded click transform data and this is where you can make changes to the data as needed.